{
 "cells": [
  {
   "cell_type": "code",
   "execution_count": 2,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "import pandas as pd\n",
    "import numpy as np\n",
    "import os\n",
    "import re\n",
    "import xlwings as xw"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 20,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": [
    "app = xw.App(visible=True, add_book=False)\n",
    "app.display_alters = False\n",
    "app.screen_updating = True"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 25,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>None</th>\n",
       "      <th>9月</th>\n",
       "      <th>10月</th>\n",
       "      <th>11月</th>\n",
       "      <th>12月</th>\n",
       "      <th>1月</th>\n",
       "      <th>2月</th>\n",
       "      <th>3月</th>\n",
       "      <th>4月</th>\n",
       "      <th>5月</th>\n",
       "      <th>6月</th>\n",
       "      <th>7月</th>\n",
       "      <th>8月</th>\n",
       "      <th>9月</th>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>项目</th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "      <th></th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>棉羽台产</th>\n",
       "      <td>None</td>\n",
       "      <td>8.0</td>\n",
       "      <td>9.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>10.0</td>\n",
       "      <td>20（裤子）</td>\n",
       "      <td>20（裤子）</td>\n",
       "      <td>20（裤子）</td>\n",
       "      <td>20（裤子）</td>\n",
       "      <td>20（裤子）</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>8.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>车工</th>\n",
       "      <td>人数</td>\n",
       "      <td>224.0</td>\n",
       "      <td>224.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>200.0</td>\n",
       "      <td>190</td>\n",
       "      <td>190</td>\n",
       "      <td>198</td>\n",
       "      <td>198</td>\n",
       "      <td>202</td>\n",
       "      <td>202.0</td>\n",
       "      <td>208.0</td>\n",
       "      <td>208.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月工作天数</td>\n",
       "      <td>24.7</td>\n",
       "      <td>24.7</td>\n",
       "      <td>25.3</td>\n",
       "      <td>25.3</td>\n",
       "      <td>16.1</td>\n",
       "      <td>16.1</td>\n",
       "      <td>22.4</td>\n",
       "      <td>22.4</td>\n",
       "      <td>23.8</td>\n",
       "      <td>23.8</td>\n",
       "      <td>24.3</td>\n",
       "      <td>24.3</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月实际天数</td>\n",
       "      <td>27.5</td>\n",
       "      <td>27.5</td>\n",
       "      <td>27.5</td>\n",
       "      <td>27.5</td>\n",
       "      <td>27.5</td>\n",
       "      <td>27.5</td>\n",
       "      <td>25.5</td>\n",
       "      <td>25.5</td>\n",
       "      <td>26.5</td>\n",
       "      <td>26.5</td>\n",
       "      <td>27.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月工作时间（小时）</td>\n",
       "      <td>14.8</td>\n",
       "      <td>14.8</td>\n",
       "      <td>15.6</td>\n",
       "      <td>15.6</td>\n",
       "      <td>3</td>\n",
       "      <td>3</td>\n",
       "      <td>16.5</td>\n",
       "      <td>16.5</td>\n",
       "      <td>18</td>\n",
       "      <td>18.0</td>\n",
       "      <td>18.5</td>\n",
       "      <td>18.5</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月均工资</td>\n",
       "      <td>2114.1</td>\n",
       "      <td>2114.1</td>\n",
       "      <td>2237.6</td>\n",
       "      <td>2237.6</td>\n",
       "      <td>435.9</td>\n",
       "      <td>435.9</td>\n",
       "      <td>2352.5</td>\n",
       "      <td>2352.5</td>\n",
       "      <td>2575.2</td>\n",
       "      <td>2575.2</td>\n",
       "      <td>2650.3</td>\n",
       "      <td>2650.3</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月实际工资</td>\n",
       "      <td>2349.6</td>\n",
       "      <td>2349.6</td>\n",
       "      <td>2432.4</td>\n",
       "      <td>2432.4</td>\n",
       "      <td>743</td>\n",
       "      <td>743</td>\n",
       "      <td>2680.6</td>\n",
       "      <td>2680.6</td>\n",
       "      <td>2862.5</td>\n",
       "      <td>2862.5</td>\n",
       "      <td>2938.8</td>\n",
       "      <td>2938.8</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>裁床</th>\n",
       "      <td>人数</td>\n",
       "      <td>14.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>14.0</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>11</td>\n",
       "      <td>15</td>\n",
       "      <td>15.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>16.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月工作天数</td>\n",
       "      <td>25.3</td>\n",
       "      <td>25.3</td>\n",
       "      <td>22.3</td>\n",
       "      <td>22.3</td>\n",
       "      <td>18.4</td>\n",
       "      <td>18.4</td>\n",
       "      <td>25.7</td>\n",
       "      <td>25.7</td>\n",
       "      <td>23.3</td>\n",
       "      <td>23.3</td>\n",
       "      <td>26.4</td>\n",
       "      <td>26.4</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月实际天数</td>\n",
       "      <td>26.5</td>\n",
       "      <td>26.5</td>\n",
       "      <td>26.5</td>\n",
       "      <td>26.5</td>\n",
       "      <td>26.5</td>\n",
       "      <td>26.5</td>\n",
       "      <td>26.3</td>\n",
       "      <td>26.3</td>\n",
       "      <td>26.5</td>\n",
       "      <td>26.5</td>\n",
       "      <td>26.5</td>\n",
       "      <td>26.5</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月工作时间（小时）</td>\n",
       "      <td>21.3</td>\n",
       "      <td>21.3</td>\n",
       "      <td>19.4</td>\n",
       "      <td>19.4</td>\n",
       "      <td>17.1</td>\n",
       "      <td>17.1</td>\n",
       "      <td>23.6</td>\n",
       "      <td>23.6</td>\n",
       "      <td>20.9</td>\n",
       "      <td>20.9</td>\n",
       "      <td>23.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月均工资</td>\n",
       "      <td>3039.7</td>\n",
       "      <td>3039.7</td>\n",
       "      <td>2771.3</td>\n",
       "      <td>2771.3</td>\n",
       "      <td>2450.9</td>\n",
       "      <td>2450.9</td>\n",
       "      <td>3371.1</td>\n",
       "      <td>3371.1</td>\n",
       "      <td>2994.2</td>\n",
       "      <td>2994.2</td>\n",
       "      <td>3286.2</td>\n",
       "      <td>3286.2</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月实际工资</td>\n",
       "      <td>3183.9</td>\n",
       "      <td>3183.9</td>\n",
       "      <td>3287.4</td>\n",
       "      <td>3287.4</td>\n",
       "      <td>3528.1</td>\n",
       "      <td>3528.1</td>\n",
       "      <td>3448.8</td>\n",
       "      <td>3448.8</td>\n",
       "      <td>3405.5</td>\n",
       "      <td>3405.5</td>\n",
       "      <td>3296.0</td>\n",
       "      <td>3296.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>整烫</th>\n",
       "      <td>人数</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月工作天数</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月实际天数</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月工作时间（小时）</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月均工资</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月实际工资</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>包装</th>\n",
       "      <td>人数</td>\n",
       "      <td>63.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>63.0</td>\n",
       "      <td>64</td>\n",
       "      <td>64</td>\n",
       "      <td>62</td>\n",
       "      <td>62</td>\n",
       "      <td>62</td>\n",
       "      <td>62.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>69.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月工作天数</td>\n",
       "      <td>21.0</td>\n",
       "      <td>21.0</td>\n",
       "      <td>22.6</td>\n",
       "      <td>22.6</td>\n",
       "      <td>15.4</td>\n",
       "      <td>15.4</td>\n",
       "      <td>22.3</td>\n",
       "      <td>22.3</td>\n",
       "      <td>21</td>\n",
       "      <td>21.0</td>\n",
       "      <td>21.3</td>\n",
       "      <td>21.3</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月实际天数</td>\n",
       "      <td>29.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>29</td>\n",
       "      <td>29</td>\n",
       "      <td>27</td>\n",
       "      <td>27</td>\n",
       "      <td>26.5</td>\n",
       "      <td>26.5</td>\n",
       "      <td>28.3</td>\n",
       "      <td>28.3</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月工作时间（小时）</td>\n",
       "      <td>13.4</td>\n",
       "      <td>13.4</td>\n",
       "      <td>11.8</td>\n",
       "      <td>11.8</td>\n",
       "      <td>13.1</td>\n",
       "      <td>13.1</td>\n",
       "      <td>13.6</td>\n",
       "      <td>13.6</td>\n",
       "      <td>12.6</td>\n",
       "      <td>12.6</td>\n",
       "      <td>11.6</td>\n",
       "      <td>11.6</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月均工资</td>\n",
       "      <td>1919.1</td>\n",
       "      <td>1919.1</td>\n",
       "      <td>1683.7</td>\n",
       "      <td>1683.7</td>\n",
       "      <td>1867.3</td>\n",
       "      <td>1867.3</td>\n",
       "      <td>1939.5</td>\n",
       "      <td>1939.5</td>\n",
       "      <td>1794.7</td>\n",
       "      <td>1794.7</td>\n",
       "      <td>1664.4</td>\n",
       "      <td>1664.4</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月实际工资</td>\n",
       "      <td>2655.3</td>\n",
       "      <td>2655.3</td>\n",
       "      <td>2165.2</td>\n",
       "      <td>2165.2</td>\n",
       "      <td>3514</td>\n",
       "      <td>3514</td>\n",
       "      <td>2349.7</td>\n",
       "      <td>2349.7</td>\n",
       "      <td>2263.4</td>\n",
       "      <td>2263.4</td>\n",
       "      <td>2211.1</td>\n",
       "      <td>2211.1</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>检验</th>\n",
       "      <td>人数</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月工作天数</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月实际天数</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月工作时间（小时）</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月均工资</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月实际工资</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>锁定</th>\n",
       "      <td>人数</td>\n",
       "      <td>29.0</td>\n",
       "      <td>29.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>23.0</td>\n",
       "      <td>16</td>\n",
       "      <td>16</td>\n",
       "      <td>21</td>\n",
       "      <td>21</td>\n",
       "      <td>19</td>\n",
       "      <td>19.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>27.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月工作天数</td>\n",
       "      <td>25.3</td>\n",
       "      <td>25.3</td>\n",
       "      <td>20.6</td>\n",
       "      <td>20.6</td>\n",
       "      <td>14.3</td>\n",
       "      <td>14.3</td>\n",
       "      <td>23.4</td>\n",
       "      <td>23.4</td>\n",
       "      <td>21.5</td>\n",
       "      <td>21.5</td>\n",
       "      <td>22.0</td>\n",
       "      <td>22.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月实际天数</td>\n",
       "      <td>23.5</td>\n",
       "      <td>23.5</td>\n",
       "      <td>23.5</td>\n",
       "      <td>23.5</td>\n",
       "      <td>23.5</td>\n",
       "      <td>23.5</td>\n",
       "      <td>26.3</td>\n",
       "      <td>26.3</td>\n",
       "      <td>26</td>\n",
       "      <td>26.0</td>\n",
       "      <td>27.5</td>\n",
       "      <td>27.5</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月工作时间（小时）</td>\n",
       "      <td>21.5</td>\n",
       "      <td>21.5</td>\n",
       "      <td>17.6</td>\n",
       "      <td>17.6</td>\n",
       "      <td>12.6</td>\n",
       "      <td>12.6</td>\n",
       "      <td>20.6</td>\n",
       "      <td>20.6</td>\n",
       "      <td>18.9</td>\n",
       "      <td>18.9</td>\n",
       "      <td>19.9</td>\n",
       "      <td>19.9</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月均工资</td>\n",
       "      <td>3074.2</td>\n",
       "      <td>3074.2</td>\n",
       "      <td>2520.0</td>\n",
       "      <td>2520.0</td>\n",
       "      <td>1796.6</td>\n",
       "      <td>1796.6</td>\n",
       "      <td>2950.3</td>\n",
       "      <td>2950.3</td>\n",
       "      <td>2709</td>\n",
       "      <td>2709.0</td>\n",
       "      <td>2846.3</td>\n",
       "      <td>2846.3</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>月实际工资</td>\n",
       "      <td>2860.1</td>\n",
       "      <td>2860.1</td>\n",
       "      <td>2878.1</td>\n",
       "      <td>2878.1</td>\n",
       "      <td>2946.6</td>\n",
       "      <td>2946.6</td>\n",
       "      <td>3303.9</td>\n",
       "      <td>3303.9</td>\n",
       "      <td>3282</td>\n",
       "      <td>3282.0</td>\n",
       "      <td>3554.9</td>\n",
       "      <td>3554.9</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>总人数</th>\n",
       "      <td>None</td>\n",
       "      <td>296.0</td>\n",
       "      <td>296.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>270.0</td>\n",
       "      <td>261</td>\n",
       "      <td>261</td>\n",
       "      <td>250</td>\n",
       "      <td>250</td>\n",
       "      <td>264</td>\n",
       "      <td>264.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>266.0</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>NaN</th>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "            NaN      9月     10月     11月     12月      1月      2月      3月  \\\n",
       "项目                                                                        \n",
       "棉羽台产       None     8.0     9.0    10.0    10.0  20（裤子）  20（裤子）  20（裤子）   \n",
       "车工           人数   224.0   224.0   200.0   200.0     190     190     198   \n",
       "NaN       月工作天数    24.7    24.7    25.3    25.3    16.1    16.1    22.4   \n",
       "NaN       月实际天数    27.5    27.5    27.5    27.5    27.5    27.5    25.5   \n",
       "NaN   月工作时间（小时）    14.8    14.8    15.6    15.6       3       3    16.5   \n",
       "NaN        月均工资  2114.1  2114.1  2237.6  2237.6   435.9   435.9  2352.5   \n",
       "NaN       月实际工资  2349.6  2349.6  2432.4  2432.4     743     743  2680.6   \n",
       "裁床           人数    14.0    14.0    14.0    14.0      11      11      11   \n",
       "NaN       月工作天数    25.3    25.3    22.3    22.3    18.4    18.4    25.7   \n",
       "NaN       月实际天数    26.5    26.5    26.5    26.5    26.5    26.5    26.3   \n",
       "NaN   月工作时间（小时）    21.3    21.3    19.4    19.4    17.1    17.1    23.6   \n",
       "NaN        月均工资  3039.7  3039.7  2771.3  2771.3  2450.9  2450.9  3371.1   \n",
       "NaN       月实际工资  3183.9  3183.9  3287.4  3287.4  3528.1  3528.1  3448.8   \n",
       "整烫           人数     NaN     NaN     NaN     NaN    None    None    None   \n",
       "NaN       月工作天数     NaN     NaN     NaN     NaN    None    None    None   \n",
       "NaN       月实际天数     NaN     NaN     NaN     NaN    None    None    None   \n",
       "NaN   月工作时间（小时）     NaN     NaN     NaN     NaN    None    None    None   \n",
       "NaN        月均工资     NaN     NaN     NaN     NaN    None    None    None   \n",
       "NaN       月实际工资     NaN     NaN     NaN     NaN    None    None    None   \n",
       "包装           人数    63.0    63.0    63.0    63.0      64      64      62   \n",
       "NaN       月工作天数    21.0    21.0    22.6    22.6    15.4    15.4    22.3   \n",
       "NaN       月实际天数    29.0    29.0    29.0    29.0      29      29      27   \n",
       "NaN   月工作时间（小时）    13.4    13.4    11.8    11.8    13.1    13.1    13.6   \n",
       "NaN        月均工资  1919.1  1919.1  1683.7  1683.7  1867.3  1867.3  1939.5   \n",
       "NaN       月实际工资  2655.3  2655.3  2165.2  2165.2    3514    3514  2349.7   \n",
       "检验           人数     NaN     NaN     NaN     NaN    None    None    None   \n",
       "NaN       月工作天数     NaN     NaN     NaN     NaN    None    None    None   \n",
       "NaN       月实际天数     NaN     NaN     NaN     NaN    None    None    None   \n",
       "NaN   月工作时间（小时）     NaN     NaN     NaN     NaN    None    None    None   \n",
       "NaN        月均工资     NaN     NaN     NaN     NaN    None    None    None   \n",
       "NaN       月实际工资     NaN     NaN     NaN     NaN    None    None    None   \n",
       "锁定           人数    29.0    29.0    23.0    23.0      16      16      21   \n",
       "NaN       月工作天数    25.3    25.3    20.6    20.6    14.3    14.3    23.4   \n",
       "NaN       月实际天数    23.5    23.5    23.5    23.5    23.5    23.5    26.3   \n",
       "NaN   月工作时间（小时）    21.5    21.5    17.6    17.6    12.6    12.6    20.6   \n",
       "NaN        月均工资  3074.2  3074.2  2520.0  2520.0  1796.6  1796.6  2950.3   \n",
       "NaN       月实际工资  2860.1  2860.1  2878.1  2878.1  2946.6  2946.6  3303.9   \n",
       "总人数        None   296.0   296.0   270.0   270.0     261     261     250   \n",
       "NaN        None     NaN     NaN     NaN     NaN    None    None    None   \n",
       "NaN        None     NaN     NaN     NaN     NaN    None    None    None   \n",
       "NaN        None     NaN     NaN     NaN     NaN    None    None    None   \n",
       "NaN        None     NaN     NaN     NaN     NaN    None    None    None   \n",
       "NaN        None     NaN     NaN     NaN     NaN    None    None    None   \n",
       "\n",
       "          4月      5月      6月      7月      8月    9月  \n",
       "项目                                                  \n",
       "棉羽台产  20（裤子）  20（裤子）     8.0     8.0     8.0  None  \n",
       "车工       198     202   202.0   208.0   208.0  None  \n",
       "NaN     22.4    23.8    23.8    24.3    24.3  None  \n",
       "NaN     25.5    26.5    26.5    27.0    27.0  None  \n",
       "NaN     16.5      18    18.0    18.5    18.5  None  \n",
       "NaN   2352.5  2575.2  2575.2  2650.3  2650.3  None  \n",
       "NaN   2680.6  2862.5  2862.5  2938.8  2938.8  None  \n",
       "裁床        11      15    15.0    16.0    16.0  None  \n",
       "NaN     25.7    23.3    23.3    26.4    26.4  None  \n",
       "NaN     26.3    26.5    26.5    26.5    26.5  None  \n",
       "NaN     23.6    20.9    20.9    23.0    23.0  None  \n",
       "NaN   3371.1  2994.2  2994.2  3286.2  3286.2  None  \n",
       "NaN   3448.8  3405.5  3405.5  3296.0  3296.0  None  \n",
       "整烫      None    None     NaN     NaN     NaN  None  \n",
       "NaN     None    None     NaN     NaN     NaN  None  \n",
       "NaN     None    None     NaN     NaN     NaN  None  \n",
       "NaN     None    None     NaN     NaN     NaN  None  \n",
       "NaN     None    None     NaN     NaN     NaN  None  \n",
       "NaN     None    None     NaN     NaN     NaN  None  \n",
       "包装        62      62    62.0    69.0    69.0  None  \n",
       "NaN     22.3      21    21.0    21.3    21.3  None  \n",
       "NaN       27    26.5    26.5    28.3    28.3  None  \n",
       "NaN     13.6    12.6    12.6    11.6    11.6  None  \n",
       "NaN   1939.5  1794.7  1794.7  1664.4  1664.4  None  \n",
       "NaN   2349.7  2263.4  2263.4  2211.1  2211.1  None  \n",
       "检验      None    None     NaN     NaN     NaN  None  \n",
       "NaN     None    None     NaN     NaN     NaN  None  \n",
       "NaN     None    None     NaN     NaN     NaN  None  \n",
       "NaN     None    None     NaN     NaN     NaN  None  \n",
       "NaN     None    None     NaN     NaN     NaN  None  \n",
       "NaN     None    None     NaN     NaN     NaN  None  \n",
       "锁定        21      19    19.0    27.0    27.0  None  \n",
       "NaN     23.4    21.5    21.5    22.0    22.0  None  \n",
       "NaN     26.3      26    26.0    27.5    27.5  None  \n",
       "NaN     20.6    18.9    18.9    19.9    19.9  None  \n",
       "NaN   2950.3    2709  2709.0  2846.3  2846.3  None  \n",
       "NaN   3303.9    3282  3282.0  3554.9  3554.9  None  \n",
       "总人数      250     264   264.0   266.0   266.0  None  \n",
       "NaN     None    None     NaN     NaN     NaN  None  \n",
       "NaN     None    None     NaN     NaN     NaN  None  \n",
       "NaN     None    None     NaN     NaN     NaN  None  \n",
       "NaN     None    None     NaN     NaN     NaN  None  \n",
       "NaN     None    None     NaN     NaN     NaN  None  "
      ]
     },
     "execution_count": 25,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "xb = app.books.open(r'H:\\工资.xlsx')\n",
    "init_data = xb.sheets['sheet1'].range('a7:o50').options(pd.DataFrame).value\n",
    "init_data"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 41,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "43"
      ]
     },
     "execution_count": 41,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "worker_type = ['车工', '裁床', '整烫', '包装', '检验', '锁定', '总人数']\n",
    "len(init_data)"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 84,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "[296.0,\n",
       " 296.0,\n",
       " 270.0,\n",
       " 270.0,\n",
       " 261.0,\n",
       " 261.0,\n",
       " 250.0,\n",
       " 250.0,\n",
       " 264.0,\n",
       " 264.0,\n",
       " 266.0,\n",
       " 266.0,\n",
       " None]"
      ]
     },
     "execution_count": 84,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "init_data.loc['总人数'][1:].tolist()\n"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 87,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/plain": [
       "dict_keys(['车工', '裁床', '整烫', '包装', '检验', '锁定'])"
      ]
     },
     "execution_count": 87,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "dic = {}\n",
    "for i in range(6):\n",
    "    a = init_data.iloc[i*6+1:i*6+7, 1:].T\n",
    "    a.columns = ['人数', '月工作天数', '月实际天数', '月工作时间（小时）', '月均工资', '月实际工资']\n",
    "    a['工种'] = worker_type[i]\n",
    "    a['总人数'] = init_data.loc['总人数'][1:].tolist()\n",
    "    dic[worker_type[i]] = a\n",
    "dic.keys()"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 52,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>人数</th>\n",
       "      <th>月工作天数</th>\n",
       "      <th>月实际天数</th>\n",
       "      <th>月工作时间（小时）</th>\n",
       "      <th>月均工资</th>\n",
       "      <th>月实际工资</th>\n",
       "      <th>工种</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9月</th>\n",
       "      <td>224</td>\n",
       "      <td>24.7</td>\n",
       "      <td>27.5</td>\n",
       "      <td>14.8</td>\n",
       "      <td>2114.1</td>\n",
       "      <td>2349.6</td>\n",
       "      <td>车工</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10月</th>\n",
       "      <td>224</td>\n",
       "      <td>24.7</td>\n",
       "      <td>27.5</td>\n",
       "      <td>14.8</td>\n",
       "      <td>2114.1</td>\n",
       "      <td>2349.6</td>\n",
       "      <td>车工</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11月</th>\n",
       "      <td>200</td>\n",
       "      <td>25.3</td>\n",
       "      <td>27.5</td>\n",
       "      <td>15.6</td>\n",
       "      <td>2237.6</td>\n",
       "      <td>2432.4</td>\n",
       "      <td>车工</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12月</th>\n",
       "      <td>200</td>\n",
       "      <td>25.3</td>\n",
       "      <td>27.5</td>\n",
       "      <td>15.6</td>\n",
       "      <td>2237.6</td>\n",
       "      <td>2432.4</td>\n",
       "      <td>车工</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1月</th>\n",
       "      <td>190</td>\n",
       "      <td>16.1</td>\n",
       "      <td>27.5</td>\n",
       "      <td>3</td>\n",
       "      <td>435.9</td>\n",
       "      <td>743</td>\n",
       "      <td>车工</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2月</th>\n",
       "      <td>190</td>\n",
       "      <td>16.1</td>\n",
       "      <td>27.5</td>\n",
       "      <td>3</td>\n",
       "      <td>435.9</td>\n",
       "      <td>743</td>\n",
       "      <td>车工</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3月</th>\n",
       "      <td>198</td>\n",
       "      <td>22.4</td>\n",
       "      <td>25.5</td>\n",
       "      <td>16.5</td>\n",
       "      <td>2352.5</td>\n",
       "      <td>2680.6</td>\n",
       "      <td>车工</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4月</th>\n",
       "      <td>198</td>\n",
       "      <td>22.4</td>\n",
       "      <td>25.5</td>\n",
       "      <td>16.5</td>\n",
       "      <td>2352.5</td>\n",
       "      <td>2680.6</td>\n",
       "      <td>车工</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5月</th>\n",
       "      <td>202</td>\n",
       "      <td>23.8</td>\n",
       "      <td>26.5</td>\n",
       "      <td>18</td>\n",
       "      <td>2575.2</td>\n",
       "      <td>2862.5</td>\n",
       "      <td>车工</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6月</th>\n",
       "      <td>202</td>\n",
       "      <td>23.8</td>\n",
       "      <td>26.5</td>\n",
       "      <td>18</td>\n",
       "      <td>2575.2</td>\n",
       "      <td>2862.5</td>\n",
       "      <td>车工</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7月</th>\n",
       "      <td>208</td>\n",
       "      <td>24.3</td>\n",
       "      <td>27</td>\n",
       "      <td>18.5</td>\n",
       "      <td>2650.3</td>\n",
       "      <td>2938.8</td>\n",
       "      <td>车工</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8月</th>\n",
       "      <td>208</td>\n",
       "      <td>24.3</td>\n",
       "      <td>27</td>\n",
       "      <td>18.5</td>\n",
       "      <td>2650.3</td>\n",
       "      <td>2938.8</td>\n",
       "      <td>车工</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9月</th>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>车工</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "       人数 月工作天数 月实际天数 月工作时间（小时）    月均工资   月实际工资  工种\n",
       "9月    224  24.7  27.5      14.8  2114.1  2349.6  车工\n",
       "10月   224  24.7  27.5      14.8  2114.1  2349.6  车工\n",
       "11月   200  25.3  27.5      15.6  2237.6  2432.4  车工\n",
       "12月   200  25.3  27.5      15.6  2237.6  2432.4  车工\n",
       "1月    190  16.1  27.5         3   435.9     743  车工\n",
       "2月    190  16.1  27.5         3   435.9     743  车工\n",
       "3月    198  22.4  25.5      16.5  2352.5  2680.6  车工\n",
       "4月    198  22.4  25.5      16.5  2352.5  2680.6  车工\n",
       "5月    202  23.8  26.5        18  2575.2  2862.5  车工\n",
       "6月    202  23.8  26.5        18  2575.2  2862.5  车工\n",
       "7月    208  24.3    27      18.5  2650.3  2938.8  车工\n",
       "8月    208  24.3    27      18.5  2650.3  2938.8  车工\n",
       "9月   None  None  None      None    None    None  车工"
      ]
     },
     "execution_count": 52,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "# a = init_data.iloc[0*6+1:0*6+7, 1:].T\n",
    "# a.columns = ['人数', '月工作天数', '月实际天数', '月工作时间（小时）', '月均工资', '月实际工资']\n",
    "# a['工种'] = worker_type[0]\n",
    "# a"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 89,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>人数</th>\n",
       "      <th>月工作天数</th>\n",
       "      <th>月实际天数</th>\n",
       "      <th>月工作时间（小时）</th>\n",
       "      <th>月均工资</th>\n",
       "      <th>月实际工资</th>\n",
       "      <th>工种</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>0</th>\n",
       "      <td>0</td>\n",
       "      <td>1</td>\n",
       "      <td>2</td>\n",
       "      <td>3</td>\n",
       "      <td>4</td>\n",
       "      <td>5</td>\n",
       "      <td>6</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "</div>"
      ],
      "text/plain": [
       "   人数  月工作天数  月实际天数  月工作时间（小时）  月均工资  月实际工资  工种\n",
       "0   0      1      2          3     4      5   6"
      ]
     },
     "execution_count": 89,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "init_df = pd.DataFrame(np.arange(7).reshape(1, 7), columns=['人数', '月工作天数', '月实际天数', '月工作时间（小时）', '月均工资', '月实际工资', '工种'])\n",
    "init_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 92,
   "metadata": {
    "collapsed": false
   },
   "outputs": [
    {
     "data": {
      "text/html": [
       "<div>\n",
       "<table border=\"1\" class=\"dataframe\">\n",
       "  <thead>\n",
       "    <tr style=\"text-align: right;\">\n",
       "      <th></th>\n",
       "      <th>人数</th>\n",
       "      <th>工种</th>\n",
       "      <th>总人数</th>\n",
       "      <th>月均工资</th>\n",
       "      <th>月实际天数</th>\n",
       "      <th>月实际工资</th>\n",
       "      <th>月工作天数</th>\n",
       "      <th>月工作时间（小时）</th>\n",
       "    </tr>\n",
       "  </thead>\n",
       "  <tbody>\n",
       "    <tr>\n",
       "      <th>9月</th>\n",
       "      <td>224</td>\n",
       "      <td>车工</td>\n",
       "      <td>296.0</td>\n",
       "      <td>2114.1</td>\n",
       "      <td>27.5</td>\n",
       "      <td>2349.6</td>\n",
       "      <td>24.7</td>\n",
       "      <td>14.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10月</th>\n",
       "      <td>224</td>\n",
       "      <td>车工</td>\n",
       "      <td>296.0</td>\n",
       "      <td>2114.1</td>\n",
       "      <td>27.5</td>\n",
       "      <td>2349.6</td>\n",
       "      <td>24.7</td>\n",
       "      <td>14.8</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11月</th>\n",
       "      <td>200</td>\n",
       "      <td>车工</td>\n",
       "      <td>270.0</td>\n",
       "      <td>2237.6</td>\n",
       "      <td>27.5</td>\n",
       "      <td>2432.4</td>\n",
       "      <td>25.3</td>\n",
       "      <td>15.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12月</th>\n",
       "      <td>200</td>\n",
       "      <td>车工</td>\n",
       "      <td>270.0</td>\n",
       "      <td>2237.6</td>\n",
       "      <td>27.5</td>\n",
       "      <td>2432.4</td>\n",
       "      <td>25.3</td>\n",
       "      <td>15.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1月</th>\n",
       "      <td>190</td>\n",
       "      <td>车工</td>\n",
       "      <td>261.0</td>\n",
       "      <td>435.9</td>\n",
       "      <td>27.5</td>\n",
       "      <td>743</td>\n",
       "      <td>16.1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2月</th>\n",
       "      <td>190</td>\n",
       "      <td>车工</td>\n",
       "      <td>261.0</td>\n",
       "      <td>435.9</td>\n",
       "      <td>27.5</td>\n",
       "      <td>743</td>\n",
       "      <td>16.1</td>\n",
       "      <td>3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3月</th>\n",
       "      <td>198</td>\n",
       "      <td>车工</td>\n",
       "      <td>250.0</td>\n",
       "      <td>2352.5</td>\n",
       "      <td>25.5</td>\n",
       "      <td>2680.6</td>\n",
       "      <td>22.4</td>\n",
       "      <td>16.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4月</th>\n",
       "      <td>198</td>\n",
       "      <td>车工</td>\n",
       "      <td>250.0</td>\n",
       "      <td>2352.5</td>\n",
       "      <td>25.5</td>\n",
       "      <td>2680.6</td>\n",
       "      <td>22.4</td>\n",
       "      <td>16.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5月</th>\n",
       "      <td>202</td>\n",
       "      <td>车工</td>\n",
       "      <td>264.0</td>\n",
       "      <td>2575.2</td>\n",
       "      <td>26.5</td>\n",
       "      <td>2862.5</td>\n",
       "      <td>23.8</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6月</th>\n",
       "      <td>202</td>\n",
       "      <td>车工</td>\n",
       "      <td>264.0</td>\n",
       "      <td>2575.2</td>\n",
       "      <td>26.5</td>\n",
       "      <td>2862.5</td>\n",
       "      <td>23.8</td>\n",
       "      <td>18</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7月</th>\n",
       "      <td>208</td>\n",
       "      <td>车工</td>\n",
       "      <td>266.0</td>\n",
       "      <td>2650.3</td>\n",
       "      <td>27</td>\n",
       "      <td>2938.8</td>\n",
       "      <td>24.3</td>\n",
       "      <td>18.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8月</th>\n",
       "      <td>208</td>\n",
       "      <td>车工</td>\n",
       "      <td>266.0</td>\n",
       "      <td>2650.3</td>\n",
       "      <td>27</td>\n",
       "      <td>2938.8</td>\n",
       "      <td>24.3</td>\n",
       "      <td>18.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9月</th>\n",
       "      <td>None</td>\n",
       "      <td>车工</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9月</th>\n",
       "      <td>14</td>\n",
       "      <td>裁床</td>\n",
       "      <td>296.0</td>\n",
       "      <td>3039.7</td>\n",
       "      <td>26.5</td>\n",
       "      <td>3183.9</td>\n",
       "      <td>25.3</td>\n",
       "      <td>21.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10月</th>\n",
       "      <td>14</td>\n",
       "      <td>裁床</td>\n",
       "      <td>296.0</td>\n",
       "      <td>3039.7</td>\n",
       "      <td>26.5</td>\n",
       "      <td>3183.9</td>\n",
       "      <td>25.3</td>\n",
       "      <td>21.3</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11月</th>\n",
       "      <td>14</td>\n",
       "      <td>裁床</td>\n",
       "      <td>270.0</td>\n",
       "      <td>2771.3</td>\n",
       "      <td>26.5</td>\n",
       "      <td>3287.4</td>\n",
       "      <td>22.3</td>\n",
       "      <td>19.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12月</th>\n",
       "      <td>14</td>\n",
       "      <td>裁床</td>\n",
       "      <td>270.0</td>\n",
       "      <td>2771.3</td>\n",
       "      <td>26.5</td>\n",
       "      <td>3287.4</td>\n",
       "      <td>22.3</td>\n",
       "      <td>19.4</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1月</th>\n",
       "      <td>11</td>\n",
       "      <td>裁床</td>\n",
       "      <td>261.0</td>\n",
       "      <td>2450.9</td>\n",
       "      <td>26.5</td>\n",
       "      <td>3528.1</td>\n",
       "      <td>18.4</td>\n",
       "      <td>17.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2月</th>\n",
       "      <td>11</td>\n",
       "      <td>裁床</td>\n",
       "      <td>261.0</td>\n",
       "      <td>2450.9</td>\n",
       "      <td>26.5</td>\n",
       "      <td>3528.1</td>\n",
       "      <td>18.4</td>\n",
       "      <td>17.1</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3月</th>\n",
       "      <td>11</td>\n",
       "      <td>裁床</td>\n",
       "      <td>250.0</td>\n",
       "      <td>3371.1</td>\n",
       "      <td>26.3</td>\n",
       "      <td>3448.8</td>\n",
       "      <td>25.7</td>\n",
       "      <td>23.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4月</th>\n",
       "      <td>11</td>\n",
       "      <td>裁床</td>\n",
       "      <td>250.0</td>\n",
       "      <td>3371.1</td>\n",
       "      <td>26.3</td>\n",
       "      <td>3448.8</td>\n",
       "      <td>25.7</td>\n",
       "      <td>23.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5月</th>\n",
       "      <td>15</td>\n",
       "      <td>裁床</td>\n",
       "      <td>264.0</td>\n",
       "      <td>2994.2</td>\n",
       "      <td>26.5</td>\n",
       "      <td>3405.5</td>\n",
       "      <td>23.3</td>\n",
       "      <td>20.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6月</th>\n",
       "      <td>15</td>\n",
       "      <td>裁床</td>\n",
       "      <td>264.0</td>\n",
       "      <td>2994.2</td>\n",
       "      <td>26.5</td>\n",
       "      <td>3405.5</td>\n",
       "      <td>23.3</td>\n",
       "      <td>20.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7月</th>\n",
       "      <td>16</td>\n",
       "      <td>裁床</td>\n",
       "      <td>266.0</td>\n",
       "      <td>3286.2</td>\n",
       "      <td>26.5</td>\n",
       "      <td>3296</td>\n",
       "      <td>26.4</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8月</th>\n",
       "      <td>16</td>\n",
       "      <td>裁床</td>\n",
       "      <td>266.0</td>\n",
       "      <td>3286.2</td>\n",
       "      <td>26.5</td>\n",
       "      <td>3296</td>\n",
       "      <td>26.4</td>\n",
       "      <td>23</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9月</th>\n",
       "      <td>None</td>\n",
       "      <td>裁床</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9月</th>\n",
       "      <td>NaN</td>\n",
       "      <td>整烫</td>\n",
       "      <td>296.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10月</th>\n",
       "      <td>NaN</td>\n",
       "      <td>整烫</td>\n",
       "      <td>296.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11月</th>\n",
       "      <td>NaN</td>\n",
       "      <td>整烫</td>\n",
       "      <td>270.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12月</th>\n",
       "      <td>NaN</td>\n",
       "      <td>整烫</td>\n",
       "      <td>270.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>...</th>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "      <td>...</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6月</th>\n",
       "      <td>62</td>\n",
       "      <td>包装</td>\n",
       "      <td>264.0</td>\n",
       "      <td>1794.7</td>\n",
       "      <td>26.5</td>\n",
       "      <td>2263.4</td>\n",
       "      <td>21</td>\n",
       "      <td>12.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7月</th>\n",
       "      <td>69</td>\n",
       "      <td>包装</td>\n",
       "      <td>266.0</td>\n",
       "      <td>1664.4</td>\n",
       "      <td>28.3</td>\n",
       "      <td>2211.1</td>\n",
       "      <td>21.3</td>\n",
       "      <td>11.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8月</th>\n",
       "      <td>69</td>\n",
       "      <td>包装</td>\n",
       "      <td>266.0</td>\n",
       "      <td>1664.4</td>\n",
       "      <td>28.3</td>\n",
       "      <td>2211.1</td>\n",
       "      <td>21.3</td>\n",
       "      <td>11.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9月</th>\n",
       "      <td>None</td>\n",
       "      <td>包装</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9月</th>\n",
       "      <td>NaN</td>\n",
       "      <td>检验</td>\n",
       "      <td>296.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10月</th>\n",
       "      <td>NaN</td>\n",
       "      <td>检验</td>\n",
       "      <td>296.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11月</th>\n",
       "      <td>NaN</td>\n",
       "      <td>检验</td>\n",
       "      <td>270.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12月</th>\n",
       "      <td>NaN</td>\n",
       "      <td>检验</td>\n",
       "      <td>270.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1月</th>\n",
       "      <td>None</td>\n",
       "      <td>检验</td>\n",
       "      <td>261.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2月</th>\n",
       "      <td>None</td>\n",
       "      <td>检验</td>\n",
       "      <td>261.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3月</th>\n",
       "      <td>None</td>\n",
       "      <td>检验</td>\n",
       "      <td>250.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4月</th>\n",
       "      <td>None</td>\n",
       "      <td>检验</td>\n",
       "      <td>250.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5月</th>\n",
       "      <td>None</td>\n",
       "      <td>检验</td>\n",
       "      <td>264.0</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6月</th>\n",
       "      <td>NaN</td>\n",
       "      <td>检验</td>\n",
       "      <td>264.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7月</th>\n",
       "      <td>NaN</td>\n",
       "      <td>检验</td>\n",
       "      <td>266.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8月</th>\n",
       "      <td>NaN</td>\n",
       "      <td>检验</td>\n",
       "      <td>266.0</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "      <td>NaN</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9月</th>\n",
       "      <td>None</td>\n",
       "      <td>检验</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9月</th>\n",
       "      <td>29</td>\n",
       "      <td>锁定</td>\n",
       "      <td>296.0</td>\n",
       "      <td>3074.2</td>\n",
       "      <td>23.5</td>\n",
       "      <td>2860.1</td>\n",
       "      <td>25.3</td>\n",
       "      <td>21.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>10月</th>\n",
       "      <td>29</td>\n",
       "      <td>锁定</td>\n",
       "      <td>296.0</td>\n",
       "      <td>3074.2</td>\n",
       "      <td>23.5</td>\n",
       "      <td>2860.1</td>\n",
       "      <td>25.3</td>\n",
       "      <td>21.5</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>11月</th>\n",
       "      <td>23</td>\n",
       "      <td>锁定</td>\n",
       "      <td>270.0</td>\n",
       "      <td>2520</td>\n",
       "      <td>23.5</td>\n",
       "      <td>2878.1</td>\n",
       "      <td>20.6</td>\n",
       "      <td>17.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>12月</th>\n",
       "      <td>23</td>\n",
       "      <td>锁定</td>\n",
       "      <td>270.0</td>\n",
       "      <td>2520</td>\n",
       "      <td>23.5</td>\n",
       "      <td>2878.1</td>\n",
       "      <td>20.6</td>\n",
       "      <td>17.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>1月</th>\n",
       "      <td>16</td>\n",
       "      <td>锁定</td>\n",
       "      <td>261.0</td>\n",
       "      <td>1796.6</td>\n",
       "      <td>23.5</td>\n",
       "      <td>2946.6</td>\n",
       "      <td>14.3</td>\n",
       "      <td>12.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>2月</th>\n",
       "      <td>16</td>\n",
       "      <td>锁定</td>\n",
       "      <td>261.0</td>\n",
       "      <td>1796.6</td>\n",
       "      <td>23.5</td>\n",
       "      <td>2946.6</td>\n",
       "      <td>14.3</td>\n",
       "      <td>12.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>3月</th>\n",
       "      <td>21</td>\n",
       "      <td>锁定</td>\n",
       "      <td>250.0</td>\n",
       "      <td>2950.3</td>\n",
       "      <td>26.3</td>\n",
       "      <td>3303.9</td>\n",
       "      <td>23.4</td>\n",
       "      <td>20.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>4月</th>\n",
       "      <td>21</td>\n",
       "      <td>锁定</td>\n",
       "      <td>250.0</td>\n",
       "      <td>2950.3</td>\n",
       "      <td>26.3</td>\n",
       "      <td>3303.9</td>\n",
       "      <td>23.4</td>\n",
       "      <td>20.6</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>5月</th>\n",
       "      <td>19</td>\n",
       "      <td>锁定</td>\n",
       "      <td>264.0</td>\n",
       "      <td>2709</td>\n",
       "      <td>26</td>\n",
       "      <td>3282</td>\n",
       "      <td>21.5</td>\n",
       "      <td>18.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>6月</th>\n",
       "      <td>19</td>\n",
       "      <td>锁定</td>\n",
       "      <td>264.0</td>\n",
       "      <td>2709</td>\n",
       "      <td>26</td>\n",
       "      <td>3282</td>\n",
       "      <td>21.5</td>\n",
       "      <td>18.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>7月</th>\n",
       "      <td>27</td>\n",
       "      <td>锁定</td>\n",
       "      <td>266.0</td>\n",
       "      <td>2846.3</td>\n",
       "      <td>27.5</td>\n",
       "      <td>3554.9</td>\n",
       "      <td>22</td>\n",
       "      <td>19.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>8月</th>\n",
       "      <td>27</td>\n",
       "      <td>锁定</td>\n",
       "      <td>266.0</td>\n",
       "      <td>2846.3</td>\n",
       "      <td>27.5</td>\n",
       "      <td>3554.9</td>\n",
       "      <td>22</td>\n",
       "      <td>19.9</td>\n",
       "    </tr>\n",
       "    <tr>\n",
       "      <th>9月</th>\n",
       "      <td>None</td>\n",
       "      <td>锁定</td>\n",
       "      <td>NaN</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "      <td>None</td>\n",
       "    </tr>\n",
       "  </tbody>\n",
       "</table>\n",
       "<p>234 rows × 8 columns</p>\n",
       "</div>"
      ],
      "text/plain": [
       "       人数  工种    总人数    月均工资 月实际天数   月实际工资 月工作天数 月工作时间（小时）\n",
       "9月    224  车工  296.0  2114.1  27.5  2349.6  24.7      14.8\n",
       "10月   224  车工  296.0  2114.1  27.5  2349.6  24.7      14.8\n",
       "11月   200  车工  270.0  2237.6  27.5  2432.4  25.3      15.6\n",
       "12月   200  车工  270.0  2237.6  27.5  2432.4  25.3      15.6\n",
       "1月    190  车工  261.0   435.9  27.5     743  16.1         3\n",
       "2月    190  车工  261.0   435.9  27.5     743  16.1         3\n",
       "3月    198  车工  250.0  2352.5  25.5  2680.6  22.4      16.5\n",
       "4月    198  车工  250.0  2352.5  25.5  2680.6  22.4      16.5\n",
       "5月    202  车工  264.0  2575.2  26.5  2862.5  23.8        18\n",
       "6月    202  车工  264.0  2575.2  26.5  2862.5  23.8        18\n",
       "7月    208  车工  266.0  2650.3    27  2938.8  24.3      18.5\n",
       "8月    208  车工  266.0  2650.3    27  2938.8  24.3      18.5\n",
       "9月   None  车工    NaN    None  None    None  None      None\n",
       "9月     14  裁床  296.0  3039.7  26.5  3183.9  25.3      21.3\n",
       "10月    14  裁床  296.0  3039.7  26.5  3183.9  25.3      21.3\n",
       "11月    14  裁床  270.0  2771.3  26.5  3287.4  22.3      19.4\n",
       "12月    14  裁床  270.0  2771.3  26.5  3287.4  22.3      19.4\n",
       "1月     11  裁床  261.0  2450.9  26.5  3528.1  18.4      17.1\n",
       "2月     11  裁床  261.0  2450.9  26.5  3528.1  18.4      17.1\n",
       "3月     11  裁床  250.0  3371.1  26.3  3448.8  25.7      23.6\n",
       "4月     11  裁床  250.0  3371.1  26.3  3448.8  25.7      23.6\n",
       "5月     15  裁床  264.0  2994.2  26.5  3405.5  23.3      20.9\n",
       "6月     15  裁床  264.0  2994.2  26.5  3405.5  23.3      20.9\n",
       "7月     16  裁床  266.0  3286.2  26.5    3296  26.4        23\n",
       "8月     16  裁床  266.0  3286.2  26.5    3296  26.4        23\n",
       "9月   None  裁床    NaN    None  None    None  None      None\n",
       "9月    NaN  整烫  296.0     NaN   NaN     NaN   NaN       NaN\n",
       "10月   NaN  整烫  296.0     NaN   NaN     NaN   NaN       NaN\n",
       "11月   NaN  整烫  270.0     NaN   NaN     NaN   NaN       NaN\n",
       "12月   NaN  整烫  270.0     NaN   NaN     NaN   NaN       NaN\n",
       "..    ...  ..    ...     ...   ...     ...   ...       ...\n",
       "6月     62  包装  264.0  1794.7  26.5  2263.4    21      12.6\n",
       "7月     69  包装  266.0  1664.4  28.3  2211.1  21.3      11.6\n",
       "8月     69  包装  266.0  1664.4  28.3  2211.1  21.3      11.6\n",
       "9月   None  包装    NaN    None  None    None  None      None\n",
       "9月    NaN  检验  296.0     NaN   NaN     NaN   NaN       NaN\n",
       "10月   NaN  检验  296.0     NaN   NaN     NaN   NaN       NaN\n",
       "11月   NaN  检验  270.0     NaN   NaN     NaN   NaN       NaN\n",
       "12月   NaN  检验  270.0     NaN   NaN     NaN   NaN       NaN\n",
       "1月   None  检验  261.0    None  None    None  None      None\n",
       "2月   None  检验  261.0    None  None    None  None      None\n",
       "3月   None  检验  250.0    None  None    None  None      None\n",
       "4月   None  检验  250.0    None  None    None  None      None\n",
       "5月   None  检验  264.0    None  None    None  None      None\n",
       "6月    NaN  检验  264.0     NaN   NaN     NaN   NaN       NaN\n",
       "7月    NaN  检验  266.0     NaN   NaN     NaN   NaN       NaN\n",
       "8月    NaN  检验  266.0     NaN   NaN     NaN   NaN       NaN\n",
       "9月   None  检验    NaN    None  None    None  None      None\n",
       "9月     29  锁定  296.0  3074.2  23.5  2860.1  25.3      21.5\n",
       "10月    29  锁定  296.0  3074.2  23.5  2860.1  25.3      21.5\n",
       "11月    23  锁定  270.0    2520  23.5  2878.1  20.6      17.6\n",
       "12月    23  锁定  270.0    2520  23.5  2878.1  20.6      17.6\n",
       "1月     16  锁定  261.0  1796.6  23.5  2946.6  14.3      12.6\n",
       "2月     16  锁定  261.0  1796.6  23.5  2946.6  14.3      12.6\n",
       "3月     21  锁定  250.0  2950.3  26.3  3303.9  23.4      20.6\n",
       "4月     21  锁定  250.0  2950.3  26.3  3303.9  23.4      20.6\n",
       "5月     19  锁定  264.0    2709    26    3282  21.5      18.9\n",
       "6月     19  锁定  264.0    2709    26    3282  21.5      18.9\n",
       "7月     27  锁定  266.0  2846.3  27.5  3554.9    22      19.9\n",
       "8月     27  锁定  266.0  2846.3  27.5  3554.9    22      19.9\n",
       "9月   None  锁定    NaN    None  None    None  None      None\n",
       "\n",
       "[234 rows x 8 columns]"
      ]
     },
     "execution_count": 92,
     "metadata": {},
     "output_type": "execute_result"
    }
   ],
   "source": [
    "for i in dic:\n",
    "    init_df = pd.concat([init_df, dic[i]])\n",
    "init_df.drop([0], axis=0, inplace=True)\n",
    "init_df"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": 93,
   "metadata": {
    "collapsed": false
   },
   "outputs": [],
   "source": [
    "init_df.to_excel('h:\\\\1111.xlsx')"
   ]
  },
  {
   "cell_type": "code",
   "execution_count": null,
   "metadata": {
    "collapsed": true
   },
   "outputs": [],
   "source": []
  }
 ],
 "metadata": {
  "kernelspec": {
   "display_name": "Python 3",
   "language": "python",
   "name": "python3"
  },
  "language_info": {
   "codemirror_mode": {
    "name": "ipython",
    "version": 3
   },
   "file_extension": ".py",
   "mimetype": "text/x-python",
   "name": "python",
   "nbconvert_exporter": "python",
   "pygments_lexer": "ipython3",
   "version": "3.6.2"
  }
 },
 "nbformat": 4,
 "nbformat_minor": 2
}
